So when we first started talking about charts I did mention that there are many different types of charts
you can work with.
Some charts are better suited for larger amounts of data.
Like a cluster call them chart.
Some charts are better suited for smaller amounts of data perhaps a single column of data or a single
row.
An example of this would be a pie chart.
Take a look.
Let's look at how you create a pie chart within Microsoft Excel.
So I'm going to go back to my quarter one sheet back to where all my data is at.
And there we go.
Now remember the first step is to select the data that you want to chart.
So I'm going to grab the same range that I grabbed earlier I'll grab from 8:3 down to deviate.
There we go.
Now what that date is selected.
I'm going to create a pie chart but remember a pie chart is better suited for a single axis of data
a single column like a single month or a single bill a single row.
Watch this.
So I've got all that data selected I'm going to go up to insert.
I'm going to go over the charts and this time I'm going to grab a pie chart and I'll just do the default
to the flat chart here.
Pie chart.
So I was like that.
And there's my chart.
Let's just move it down below and get a little bit more visual here.
So now what did you give me.
Did he give me all of the months with all the bills.
What am I looking at.
Remember a pie chart better suited for smaller amounts of data a single column a single row.
So what I really guy here is a single row worth of data.
I got ripped for all three months.
So I got a pretty equal pot pie chart there.
A little peace sign going on there right.
Well that's great right.
But maybe it's not rent that I wanted maybe I wanted gas or maybe I didn't want to bill maybe I wanted
to break this up by a month.
I want to see February's data with all of the bills.
Why don't I do that.
We talked about changing the data source earlier.
Remember that.
Take a look.
Also like my chart.
Scroll back up.
Never the color coded areas.
Now let's say I only want a specific month.
I only want February.
So I'm just going to grab the blue bar to shrink that up.
It was great this site as well.
Let's shrink that up.
And now I've just got February data.
But I'm only looking at rents.
That's weird.
February rent is not much of a pie chart.
I need to make a change here again with my chart selected.
I'm going to go to the Design tab and I have this feature called switch row column.
Right now I'm looking at this by row a single row where the data rent for a single month.
I'm going to change it from row to column and I'll get this button click.
And now I've got February with all the bills one button press actually two change the data source.
And then I switch the row column.
Now let's try the opposite.
I got just a single month but maybe it's a bill that I want I want to get credit cards.
So first I mean I swap my data here.
I want to get just credit cards.
I'm going to shrink this.
Get just credit cards.
But right now that's just for February.
So if I look down here my chart it's February again is just credit cards.
But you know what.
And you stretch that out so I get each of the months.
Let's get January and March and the next.
Look at my chart again.
Now I'm just picking up on January for credit cards.
What do I need to do
I need to switch the row column.
Because right now I'm looking at a single row.
Right.
So I'm going to hop back up here or a single column.
Excuse me I'm looking at a single column a single month.
So quick this button switch the row column.
And now I'm looking at credit cards and I can see all three months there.
So a pie chart very effective in describing your data.
Kind of more percentage wise of this 100 percent pie.
But remember it's better suited for a single column or a single row of data.
So you can manipulate the data pick up on the specific month or specific bill but remember on the Design
tab you've got the switch row column feature.
So you can pick up on the appropriate data.
Try this out.
Build a pie chart.
You decide do you want to do a specific month.
Do you want to do a specific bill worked with the switch row column get a feel for working for it with
a pie chart and how to present that data.
Try it out.